Python Job: Data Analyst

WHAT IS THE OPPORTUNITY?

Identify and analyze data to extract key information, evaluate and monitor data quality to meet the organization's information system needs and requirements.

What will you do?

• Responsible for large scale multi-way comparisons of CDR data against various internal and external sources to identify trends and to measure overall data quality
• Develop and implement reporting and data visualization dashboards to articulate trends and data quality measurements
• Develop monitoring to proactively identify data quality gaps
• Support the root cause analysis of data issues relating to client data, and perform complex remediation requiring advanced pattern recognition and machine learning
• Identify and coordinate system and process enhancements and improvements

What you need to succeed?

• Completion of an applicable university degree and/or relevant professional designation.
• A minimum of two years of experience in Python, R and or other programming languages.
• Advanced Excel Skills
  • Analyze large data sets using pivot tables and pivot reporting
  • Ability to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions; debug and audit
  • Build macros using VBA (Visual Basic for Applications)
  • Ability to structure and present data for reporting using conditional formatting, tables and charting
• Intermediate SQL skills
  • Understanding and usage of SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions
  • Understanding and usage of update and insertion statements and syntax for altering and creating structures
  • Can generate complex data reports using GROUP BY and aggregate functions
  • Understands SQL concepts of foreign keys, transactions, triggers, and stored procedures
• Excellent communication skills – written and oral
• Strong troubleshooting and problem solving skills

Nice-to-have

• Degree in Computer Science

What’s in it for you?

We thrive on the challenge to be our best, progressive thinking to keep growing, and working together to deliver trusted advice to help our clients thrive and communities prosper. We care about each other, reaching our potential, making a difference to our communities, and achieving success that is mutual.

• A comprehensive Total Rewards Program including bonuses and flexible benefits, competitive compensation
• Leaders who support your development through coaching and managing opportunities
• Work in a dynamic, collaborative, progressive, and high-performing team
• Opportunities to do challenging work
• Flexible work/life balance options